package xyz.haijin.mybatisplus.constant;

/**
 * mp查询常量
 * @author liuhaijin
 * @date 2022/1/24
 */
public interface QueryConstant {
    // 和
    String AND = "and";
    // 或
    String OR = "or";
    // 嵌套
    String NESTED = "nested";
    //等于
    String EQ = "eq";
    //不等于
    String NE = "ne";
    //大于
    String GT = "gt";
    //大于等于
    String GE = "ge";
    //小于
    String LT = "lt";
    //小于等于
    String LE = "le";
    // 在...之间
    String BETWEEN = "between";
    // 不在...之间
    String NOT_BETWEEN = "notBetween";
    // 模糊查询
    String LIKE = "like";
    // 非模糊查询
    String NOT_LIKE = "notLike";
    // 左模糊
    String LIKE_LEFT = "likeLeft";
    // 右模糊查询
    String LIKE_RIGHT = "likeRight";
    // 选择查询
    String IN = "in";
    // 非选择查询
    String NOT_IN = "notIn";
    // 为空
    String IS_NULL = "isNull";
    // 不为空
    String IS_NOT_NULL = "isNotNull";
    // 包含
    String CONTAIN_ARRAY = "contain";
    // 被包含
    String CONTAINED_BY_ARRAY = "contained_by";
    // 重叠
    String OVERLAP_ARRAY = "overlap";
    // 正序
    String ASC = "asc";
    // 倒序
    String DESC = "desc";
    // 日期
    String DATE = "date";
    // 时间戳
    String TIMESTAMP = "timestamp";
}
